package com.eduction.service;

import java.sql.SQLException;
import java.util.List;

import com.eduction.modules.system.entity.SurveyOpinion;
import com.eduction.vo.SurveyPointCountVo;

public interface SurveyOpinionService {

	/**
	 * 保存数据
	 */
	public void saveSurveyOpinionInfo(List<SurveyOpinion> so);
	
	/**
	 * 查询数据
	 * @throws SQLException 
	 */
	public SurveyOpinion querySurveyOpinionInfo(String expertId,String itemId,String schoolId,String expertType) throws SQLException;

	/**
	 * 查询数据
	 * @throws SQLException
	 */
	public SurveyOpinion querySurveyOpinionInfo(String itemId,String schoolId,String expertType) throws SQLException;
	/**
	 * 删除某专家一级指标分项考察意见表数据
	 * @param groupId
	 * @param itemId
	 * @param expertId
	 * @throws SQLException
	 */
	public void deleteAuthIinspectionOpinionss(String schoolId ,String itemId,String expertId,int type)throws SQLException;

	/**
	 * 查询该学校的数据(汇总)
	 */
	public List<SurveyOpinion> queryAllSurveyOpinion(String schoolId, String mode) throws SQLException;

	public List<SurveyOpinion> queryItemSurveyOpinion(String schoolId, String itemId,String expectType) throws SQLException;


	List<SurveyPointCountVo> queryByCount( String expectType) throws SQLException;
}
